Visual totals function

To apply function like:

§          Visual totals                           MDX Visual totals

 

available only at hierarchy functions, you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

then select

§          … any Visual totals function from submenu

 

 

In our case let us try to:

 

activate Visual totals function, so member USA will show sum of available

members from USA at the table instead of accumulated value for USA

(presenting right now).

 

Dialog will appear:

 

 

§          select OK

 

After confirmation result is: